alter table jms_dm.dm_mng_customer_daliy_project_summary_dt set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_mng_customer_daliy_project_summary_dt;
create external table jms_dm.dm_mng_customer_daliy_project_summary_dt
(
    project_name            string comment '项目名称',
    date_time               string comment '日期',
    waybill_total           int comment '总订单量',
    cancel_num              int comment '总取消量',
    need_taking_num         int comment '应揽收量',
    actual_taking_num       int comment '实际揽收量',
    no_taking_num           int comment '有单未揽收量',
    lack_taking_num         int comment '有单漏揽收量',
    transport_num           int comment '运输中量',
    del_war_num             int comment '派件中量',
    no_saft_num             int comment '未妥投量',
    sign_num                int comment '已签收量',
    intercept_num           int comment '拦截量',
    success_intercept_num   int comment '成功拦截量',
    7d_update_intercept_num int comment '轨迹断更量',
    work_order_num          int comment '客诉量',
    arbitration_num         int comment '丢失量',
    express_num             int comment '丢失量',
    xj_sign                 int comment '虚假签收量'
)
    COMMENT '客服日报汇总'
    PARTITIONED BY ( dt STRING COMMENT '订单录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_mng_customer_daliy_project_summary_dt'